Microsoft Excel Functions and Formulas by Bernd Held Brian Moriarty and Theodor Richardson

Author:Bernd Held, Brian Moriarty and Theodor Richardson
Language: eng
Format: epub
ISBN: 9781683923732
Publisher: Copyright © 2019 by Mercury Learning and Information LLC.
Published: 2019-09-15T00:00:00+00:00

Figure 8–2

NOTE:The category in cell C15 can be changed. To count several categories, just type “meat” in cell C16 and change the formula in cell A17 to this: =DCOUNT (A1:E10,E14,A14:E16).

Use the DCOUNT function to count cells in a range between x and y

Use the data in the previous example to continue working with the DCOUNT function. Here we want to count all products in the vegetable category that cost more than $1.75 but no more than $2.50.

To count cells in a specific range between x and y:

1.Copy the range A1:E1.

2.Select cell A14 and paste the copied cells with <Ctrl+V>.

3.Select cell C15 and type vegetable.

4.In cell E15 type >1.75.

5.In cell F15 type <=2.50.

6.In cell C17 type the following formula: =DCOUNT(A1:E10, E14,A14:F15).

7.Press <Enter>.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.